USE [LAFDC]
GO
/****** Object:  Trigger [dbo].[tr_PersonneLastModifiedDate]    Script Date: 11/23/2009 23:09:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[tr_PersonneLastModifiedDate] ON [dbo].[Personne]
FOR UPDATE
AS
UPDATE [Personne] SET [Personne].Last_Modified=getdate()
  FROM [Personne] INNER JOIN Inserted ON [Personne].[Prev_Id]= Inserted.[Prev_Id]